Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
MaintenanceFunctionCode | Defines the maintenance function to be performed. Valid values include creation, update or deletion of a price derivation rule eligibility | LU_RU_PRDV_MNT | Code4 | char(4) | |
RewardID (FK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | RewardDerivationRule(RU_RWD_DRVN_RU) |
RewardDerivationSequenceNumber (FK) | A sequence number used to specify the order for applying derivation rules tied to a Reward. RewardDerivationSequenceNumber always starts with 1 and is incremented by 1 for each appended derivation step tied to the Reward. | AI_RWD_DRVN_SQN_NMB | LineNumber | integer | RewardDerivationRule(RU_RWD_DRVN_RU) |